1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.IO;
6 using System.Drawing;
7 using System.Linq;
8 using System.Text;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11 using System.Data.Sql;
12 using System.Data.SqlTypes;
13 using MySql.Data.MySqlClient;
14 using MySql.Data.Entity;
15 using MySql.Data.Types;
16 using MySql.Data;
17 namespace PhoneDirectory
18 {
19 public partial class frm_add : Form
20 {
21 public frm_add()
22 {
23 InitializeComponent();
24 }
25
26 private void saveData()
27 {
28 MySqlConnection connection = new MySqlConnection("server=localhost;user=root;database=phonedirectory;port=3306;password=;");
29 connection.Open();
30 MySqlCommand cmd = new MySqlCommand();
31 cmd.Connection = connection;
32 cmd.CommandText = "INSERT INTO directory(ID ,Name,Nickname, PhoneNumber,MobileNumber, EmailAddress,HomeAddress,Company,Position,GroupName,Website,FacebookAccount,Remarks) VALUES(@ID ,@Name,@Nickname, @PhoneNumber,@MobileNumber, @EmailAddress,@HomeAddress,@Company,@Position,@GroupName,@Website,@FacebookAccount,@Remarks)";
33 cmd.Parameters.AddWithValue("@ID", null);
34 cmd.Parameters.AddWithValue("@Name", textBox1.Text);
35 cmd.Parameters.AddWithValue("@Nickname", textBox2.Text);
36 cmd.Parameters.AddWithValue("@PhoneNumber", textBox3.Text);
37 cmd.Parameters.AddWithValue("@MobileNumber", textBox4.Text);
38 cmd.Parameters.AddWithValue("@EmailAddress", textBox5.Text);
39 cmd.Parameters.AddWithValue("@HomeAddress", textBox6.Text);
40 cmd.Parameters.AddWithValue("@Company", textBox7.Text);
41 cmd.Parameters.AddWithValue("@Position", textBox8.Text);
42 cmd.Parameters.AddWithValue("@GroupName", textBox9.Text);
43 cmd.Parameters.AddWithValue("@Website", textBox10.Text);
44 cmd.Parameters.AddWithValue("@FacebookAccount", textBox11.Text);
45 cmd.Parameters.AddWithValue("@Remarks", "");
46 cmd.ExecuteNonQuery();
47 if (connection != null)
48 connection.Close();
49 MessageBox.Show("Successfully saved to directory", " System Notification");
50 }
51 private void frm_add_Load(object sender, EventArgs e)
52 {
53
54 }
55
56 private void button1_Click(object sender, EventArgs e)
57 {
58 try
59 {
60 saveData();
61 }
62 catch (Exception er)
63 {
64 MessageBox.Show(er.Message);
65 }
66 }
67 }
68 }